SpdrExchRiskReset

V8 Message Definiton

SpdrExchRiskMgmt records are created/published by SpiderRock Execution Engines and show exchange level risk management child order rejects.

METADATA

Attribute	Value
Topic	3790-order-routing-control
MLink Token	SystemData
Product	SRTrade
accessType	SELECT,UPDATE,INSERT,DELETE

Table Definition

Field	Type	Key	Default Value	Comment
clientFirm	VARCHAR(16)	PRI	''
exch	VARCHAR(8)	PRI	''
securityGroup	VARCHAR(6)	PRI	''
modifiedBy	VARCHAR(24)		''	user who last modified this record
modifiedIn	enum - SysEnvironment		'None'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	timestamp of last modification

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
clientFirm	1
exch	2
securityGroup	3

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRTrade`.`MsgSRExchRiskReset` (
    `clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
    `exch` VARCHAR(8) NOT NULL DEFAULT '',
    `securityGroup` VARCHAR(6) NOT NULL DEFAULT '',
    `modifiedBy` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'user who last modified this record',
    `modifiedIn` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'timestamp of last modification',
    PRIMARY KEY USING HASH (`clientFirm`,`exch`,`securityGroup`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='SpdrExchRiskMgmt records are created/published by SpiderRock Execution Engines and show exchange level risk management child order rejects.';

SELECT TABLE EXAMPLE QUERY

SELECT
    `clientFirm`,
    `exch`,
    `securityGroup`,
    `timestamp`
FROM `SRTrade`.`MsgSRExchRiskReset`
WHERE 
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm'
  AND
    /* Replace with a VARCHAR(8) */ 
    `exch` = 'Example_exch'
  AND
    /* Replace with a VARCHAR(6) */ 
    `securityGroup` = 'Example_securityGroup';

UPDATE TABLE EXAMPLE QUERY

UPDATE `SRTrade`.`MsgSRExchRiskReset` 
SET
    /* Replace with a DATETIME(6) */
    `timestamp` = '2022-01-01 12:34:56.000000'
WHERE
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm'
  AND
    /* Replace with a VARCHAR(8) */ 
    `exch` = 'Example_exch'
  AND
    /* Replace with a VARCHAR(6) */ 
    `securityGroup` = 'Example_securityGroup';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRTrade`.`MsgSRExchRiskReset`(
    /* Replace with a VARCHAR(16) */ 
    `clientFirm`,
    /* Replace with a VARCHAR(8) */ 
    `exch`,
    /* Replace with a VARCHAR(6) */ 
    `securityGroup`,
    /* Replace with a DATETIME(6) */
    `timestamp`
) 
VALUES(
    'Example_clientFirm',
    'Example_exch',
    'Example_securityGroup',
    '2022-01-01 12:34:56.000000'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRTrade`.`MsgSRExchRiskReset` 
WHERE
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm'
  AND
    /* Replace with a VARCHAR(8) */ 
    `exch` = 'Example_exch'
  AND
    /* Replace with a VARCHAR(6) */ 
    `securityGroup` = 'Example_securityGroup';

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SpdrExchRiskReset' ORDER BY ordinal_position ASC;